Overview

Brought to you by YData

Dataset statistics

Number of variables	23
Number of observations	3840312
Missing cells	5877356
Missing cells (%)	6.7%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	875.7 MiB
Average record size in memory	239.1 B

Variable types

Numeric	22
Categorical	1

Alerts

`AMT_BALANCE` is highly overall correlated with `AMT_DRAWINGS_CURRENT` and 7 other fields	High correlation
`AMT_DRAWINGS_ATM_CURRENT` is highly overall correlated with `AMT_DRAWINGS_CURRENT` and 2 other fields	High correlation
`AMT_DRAWINGS_CURRENT` is highly overall correlated with `AMT_BALANCE` and 6 other fields	High correlation
`AMT_DRAWINGS_OTHER_CURRENT` is highly overall correlated with `CNT_DRAWINGS_OTHER_CURRENT`	High correlation
`AMT_DRAWINGS_POS_CURRENT` is highly overall correlated with `AMT_DRAWINGS_CURRENT` and 2 other fields	High correlation
`AMT_INST_MIN_REGULARITY` is highly overall correlated with `AMT_BALANCE` and 5 other fields	High correlation
`AMT_PAYMENT_CURRENT` is highly overall correlated with `AMT_BALANCE` and 5 other fields	High correlation
`AMT_PAYMENT_TOTAL_CURRENT` is highly overall correlated with `AMT_BALANCE` and 5 other fields	High correlation
`AMT_RECEIVABLE_PRINCIPAL` is highly overall correlated with `AMT_BALANCE` and 7 other fields	High correlation
`AMT_RECIVABLE` is highly overall correlated with `AMT_BALANCE` and 5 other fields	High correlation
`AMT_TOTAL_RECEIVABLE` is highly overall correlated with `AMT_BALANCE` and 5 other fields	High correlation
`CNT_DRAWINGS_ATM_CURRENT` is highly overall correlated with `AMT_DRAWINGS_ATM_CURRENT` and 2 other fields	High correlation
`CNT_DRAWINGS_CURRENT` is highly overall correlated with `AMT_BALANCE` and 6 other fields	High correlation
`CNT_DRAWINGS_OTHER_CURRENT` is highly overall correlated with `AMT_DRAWINGS_OTHER_CURRENT`	High correlation
`CNT_DRAWINGS_POS_CURRENT` is highly overall correlated with `AMT_DRAWINGS_CURRENT` and 2 other fields	High correlation
`SK_DPD` is highly overall correlated with `SK_DPD_DEF`	High correlation
`SK_DPD_DEF` is highly overall correlated with `SK_DPD`	High correlation
`NAME_CONTRACT_STATUS` is highly imbalanced (91.2%)	Imbalance
`AMT_DRAWINGS_ATM_CURRENT` has 749816 (19.5%) missing values	Missing
`AMT_DRAWINGS_OTHER_CURRENT` has 749816 (19.5%) missing values	Missing
`AMT_DRAWINGS_POS_CURRENT` has 749816 (19.5%) missing values	Missing
`AMT_INST_MIN_REGULARITY` has 305236 (7.9%) missing values	Missing
`AMT_PAYMENT_CURRENT` has 767988 (20.0%) missing values	Missing
`CNT_DRAWINGS_ATM_CURRENT` has 749816 (19.5%) missing values	Missing
`CNT_DRAWINGS_OTHER_CURRENT` has 749816 (19.5%) missing values	Missing
`CNT_DRAWINGS_POS_CURRENT` has 749816 (19.5%) missing values	Missing
`CNT_INSTALMENT_MATURE_CUM` has 305236 (7.9%) missing values	Missing
`AMT_DRAWINGS_OTHER_CURRENT` is highly skewed (γ1 = 50.57035044)	Skewed
`CNT_DRAWINGS_OTHER_CURRENT` is highly skewed (γ1 = 26.3238188)	Skewed
`SK_DPD_DEF` is highly skewed (γ1 = 89.83043358)	Skewed
`AMT_BALANCE` has 2156420 (56.2%) zeros	Zeros
`AMT_CREDIT_LIMIT_ACTUAL` has 753823 (19.6%) zeros	Zeros
`AMT_DRAWINGS_ATM_CURRENT` has 2665718 (69.4%) zeros	Zeros
`AMT_DRAWINGS_CURRENT` has 3223443 (83.9%) zeros	Zeros
`AMT_DRAWINGS_OTHER_CURRENT` has 3078163 (80.2%) zeros	Zeros
`AMT_DRAWINGS_POS_CURRENT` has 2825595 (73.6%) zeros	Zeros
`AMT_INST_MIN_REGULARITY` has 1928864 (50.2%) zeros	Zeros
`AMT_PAYMENT_CURRENT` has 390507 (10.2%) zeros	Zeros
`AMT_PAYMENT_TOTAL_CURRENT` has 2172223 (56.6%) zeros	Zeros
`AMT_RECEIVABLE_PRINCIPAL` has 2296167 (59.8%) zeros	Zeros
`AMT_RECIVABLE` has 2113816 (55.0%) zeros	Zeros
`AMT_TOTAL_RECEIVABLE` has 2113643 (55.0%) zeros	Zeros
`CNT_DRAWINGS_ATM_CURRENT` has 2665718 (69.4%) zeros	Zeros
`CNT_DRAWINGS_CURRENT` has 3229952 (84.1%) zeros	Zeros
`CNT_DRAWINGS_OTHER_CURRENT` has 3077688 (80.1%) zeros	Zeros
`CNT_DRAWINGS_POS_CURRENT` has 2825594 (73.6%) zeros	Zeros
`CNT_INSTALMENT_MATURE_CUM` has 551467 (14.4%) zeros	Zeros
`SK_DPD` has 3686957 (96.0%) zeros	Zeros
`SK_DPD_DEF` has 3750972 (97.7%) zeros	Zeros

Reproduction

Analysis started	2025-02-02 10:18:33.802325
Analysis finished	2025-02-02 10:38:18.289621
Duration	19 minutes and 44.49 seconds
Software version	ydata-profiling vv4.12.2
Download configuration	config.json

SK_ID_PREV
Real number (ℝ)

Distinct	104307
Distinct (%)	2.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1904503.6

Minimum	1000018
Maximum	2843496
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	29.3 MiB

Quantile statistics

Minimum	1000018
5-th percentile	1082648
Q1	1434385
median	1897122
Q3	2369327.8
95-th percentile	2748797
Maximum	2843496
Range	1843478
Interquartile range (IQR)	934942.75

Descriptive statistics

Standard deviation	536469.47
Coefficient of variation (CV)	0.28168467
Kurtosis	-1.2196066
Mean	1904503.6
Median Absolute Deviation (MAD)	469296
Skewness	0.038385485
Sum	7.313888 × 10¹²
Variance	2.8779949 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2377894	96	< 0.1%
2581635	96	< 0.1%
1130707	96	< 0.1%
1602951	96	< 0.1%
2775491	96	< 0.1%
1079971	96	< 0.1%
1184786	96	< 0.1%
2817372	96	< 0.1%
1017996	96	< 0.1%
2567670	96	< 0.1%
Other values (104297)	3839352	> 99.9%

Value	Count	Frequency (%)
1000018	5	< 0.1%
1000030	8	< 0.1%
1000031	16	< 0.1%
1000035	5	< 0.1%
1000077	11	< 0.1%
1000083	13	< 0.1%
1000087	32	< 0.1%
1000089	5	< 0.1%
1000094	88	< 0.1%
1000096	96	< 0.1%

Value	Count	Frequency (%)
2843496	15	< 0.1%
2843493	15	< 0.1%
2843478	90	< 0.1%
2843477	85	< 0.1%
2843476	95	< 0.1%
2843461	73	< 0.1%
2843448	39	< 0.1%
2843423	22	< 0.1%
2843414	95	< 0.1%
2843413	96	< 0.1%

SK_ID_CURR
Real number (ℝ)

Distinct	103558
Distinct (%)	2.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	278324.21

Minimum	100006
Maximum	456250
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	29.3 MiB

Quantile statistics

Minimum	100006
5-th percentile	118195
Q1	189517
median	278396
Q3	367580
95-th percentile	438161
Maximum	456250
Range	356244
Interquartile range (IQR)	178063

Descriptive statistics

Standard deviation	102704.48
Coefficient of variation (CV)	0.36901021
Kurtosis	-1.1994752
Mean	278324.21
Median Absolute Deviation (MAD)	89029
Skewness	-0.0018338367
Sum	1.0688518 × 10¹²
Variance	1.0548209 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
186401	192	< 0.1%
311118	178	< 0.1%
120076	140	< 0.1%
128827	129	< 0.1%
191826	128	< 0.1%
432607	128	< 0.1%
246089	128	< 0.1%
264667	127	< 0.1%
116448	127	< 0.1%
173773	127	< 0.1%
Other values (103548)	3838908	> 99.9%

Value	Count	Frequency (%)
100006	6	< 0.1%
100011	74	< 0.1%
100013	96	< 0.1%
100021	17	< 0.1%
100023	8	< 0.1%
100028	49	< 0.1%
100036	12	< 0.1%
100042	84	< 0.1%
100043	33	< 0.1%
100047	36	< 0.1%

Value	Count	Frequency (%)
456250	12	< 0.1%
456248	23	< 0.1%
456247	95	< 0.1%
456246	8	< 0.1%
456244	41	< 0.1%
456242	8	< 0.1%
456241	33	< 0.1%
456239	88	< 0.1%
456237	15	< 0.1%
456236	94	< 0.1%

MONTHS_BALANCE
Real number (ℝ)

Distinct	96
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-34.521921

Minimum	-96
Maximum	-1
Zeros	0
Zeros (%)	0.0%
Negative	3840312
Negative (%)	100.0%
Memory size	29.3 MiB

Quantile statistics

Minimum	-96
5-th percentile	-84
Q1	-55
median	-28
Q3	-11
95-th percentile	-3
Maximum	-1
Range	95
Interquartile range (IQR)	44

Descriptive statistics

Standard deviation	26.667751
Coefficient of variation (CV)	-0.77248747
Kurtosis	-0.85615161
Mean	-34.521921
Median Absolute Deviation (MAD)	20
Skewness	-0.59804009
Sum	-1.3257495 × 10⁸
Variance	711.16894
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-4	102115	2.7%
-5	100546	2.6%
-3	100355	2.6%
-6	98577	2.6%
-7	95332	2.5%
-2	94643	2.5%
-8	91419	2.4%
-9	86842	2.3%
-10	82525	2.1%
-11	78441	2.0%
Other values (86)	2909517	75.8%

Value	Count	Frequency (%)
-96	11722	0.3%
-95	12521	0.3%
-94	13397	0.3%
-93	14197	0.4%
-92	14911	0.4%
-91	15656	0.4%
-90	16385	0.4%
-89	17088	0.4%
-88	17806	0.5%
-87	18465	0.5%

Value	Count	Frequency (%)
-1	62356	1.6%
-2	94643	2.5%
-3	100355	2.6%
-4	102115	2.7%
-5	100546	2.6%
-6	98577	2.6%
-7	95332	2.5%
-8	91419	2.4%
-9	86842	2.3%
-10	82525	2.1%

AMT_BALANCE
Real number (ℝ)

High correlation Zeros

Distinct	1347904
Distinct (%)	35.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	58300.155

Minimum	-420250.18
Maximum	1505902.2
Zeros	2156420
Zeros (%)	56.2%
Negative	2345
Negative (%)	0.1%
Memory size	29.3 MiB

Quantile statistics

Minimum	-420250.18
5-th percentile	0
Q1	0
median	0
Q3	89046.686
95-th percentile	257181.38
Maximum	1505902.2
Range	1926152.4
Interquartile range (IQR)	89046.686

Descriptive statistics

Standard deviation	106307.03
Coefficient of variation (CV)	1.8234434
Kurtosis	11.778682
Mean	58300.155
Median Absolute Deviation (MAD)	0
Skewness	2.9201726
Sum	2.2389079 × 10¹¹
Variance	1.1301185 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2156420	56.2%
67.5	16049	0.4%
130.5	3662	0.1%
270	2313	0.1%
135	921	< 0.1%
202.5	742	< 0.1%
450	536	< 0.1%
1345.5	312	< 0.1%
92043	252	< 0.1%
46570.5	235	< 0.1%
Other values (1347894)	1658870	43.2%

Value	Count	Frequency (%)
-420250.185	1	< 0.1%
-261471.015	1	< 0.1%
-259848.945	1	< 0.1%
-240305.985	1	< 0.1%
-223224.21	2	< 0.1%
-202735.89	1	< 0.1%
-189000	1	< 0.1%
-135359.01	1	< 0.1%
-130058.82	1	< 0.1%
-104737.68	1	< 0.1%

Value	Count	Frequency (%)
1505902.185	1	< 0.1%
1354829.265	1	< 0.1%
1354613.265	1	< 0.1%
1347979.5	1	< 0.1%
1329264.63	1	< 0.1%
1229704.065	1	< 0.1%
1218896.64	1	< 0.1%
1214812.395	1	< 0.1%
1210510.755	1	< 0.1%
1150643.16	1	< 0.1%

AMT_CREDIT_LIMIT_ACTUAL
Real number (ℝ)

Zeros

Distinct	181
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	153807.96

Minimum	0
Maximum	1350000
Zeros	753823
Zeros (%)	19.6%
Negative	0
Negative (%)	0.0%
Memory size	29.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	45000
median	112500
Q3	180000
95-th percentile	450000
Maximum	1350000
Range	1350000
Interquartile range (IQR)	135000

Descriptive statistics

Standard deviation	165145.7
Coefficient of variation (CV)	1.0737136
Kurtosis	5.1840466
Mean	153807.96
Median Absolute Deviation (MAD)	67500
Skewness	2.0597324
Sum	5.9067054 × 10¹¹
Variance	2.7273102 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	753823	19.6%
180000	529292	13.8%
135000	430142	11.2%
45000	329932	8.6%
90000	319996	8.3%
67500	308866	8.0%
450000	238197	6.2%
112500	182429	4.8%
225000	162053	4.2%
270000	125935	3.3%
Other values (171)	459647	12.0%

Value	Count	Frequency (%)
0	753823	19.6%
4500	1111	< 0.1%
9000	2215	0.1%
13500	2413	0.1%
18000	735	< 0.1%
22500	652	< 0.1%
27000	7415	0.2%
31500	132	< 0.1%
36000	4473	0.1%
40500	281	< 0.1%

Value	Count	Frequency (%)
1350000	145	< 0.1%
1237500	46	< 0.1%
1125000	22	< 0.1%
1012500	7	< 0.1%
900000	33583	0.9%
891000	6	< 0.1%
864000	7	< 0.1%
855000	1533	< 0.1%
837000	6	< 0.1%
828000	13	< 0.1%

AMT_DRAWINGS_ATM_CURRENT
Real number (ℝ)

High correlation Missing Zeros

Distinct	2267
Distinct (%)	0.1%
Missing	749816
Missing (%)	19.5%
Infinite	0
Infinite (%)	0.0%
Mean	5961.3248

Minimum	-6827.31
Maximum	2115000
Zeros	2665718
Zeros (%)	69.4%
Negative	1
Negative (%)	< 0.1%
Memory size	29.3 MiB

Quantile statistics

Minimum	-6827.31
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	33750
Maximum	2115000
Range	2121827.3
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	28225.689
Coefficient of variation (CV)	4.7348013
Kurtosis	164.92753
Mean	5961.3248
Median Absolute Deviation (MAD)	0
Skewness	9.6648423
Sum	1.8423451 × 10¹⁰
Variance	7.966895 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2665718	69.4%
4500	35851	0.9%
9000	27726	0.7%
45000	22946	0.6%
2250	22854	0.6%
22500	22676	0.6%
13500	21198	0.6%
6750	14712	0.4%
18000	13318	0.3%
90000	12034	0.3%
Other values (2257)	231463	6.0%
(Missing)	749816	19.5%

Value	Count	Frequency (%)
-6827.31	1	< 0.1%
0	2665718	69.4%
45	17	< 0.1%
90	9	< 0.1%
135	9	< 0.1%
180	8	< 0.1%
225	510	< 0.1%
228.375	1	< 0.1%
270	2	< 0.1%
315	3	< 0.1%

Value	Count	Frequency (%)
2115000	1	< 0.1%
1676250	1	< 0.1%
1354500	1	< 0.1%
1350000	8	< 0.1%
1332000	1	< 0.1%
1305000	1	< 0.1%
1291950	1	< 0.1%
1237500	1	< 0.1%
1215000	1	< 0.1%
1172250	1	< 0.1%

AMT_DRAWINGS_CURRENT
Real number (ℝ)

High correlation Zeros

Distinct	187005
Distinct (%)	4.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7433.3882

Minimum	-6211.62
Maximum	2287098.3
Zeros	3223443
Zeros (%)	83.9%
Negative	3
Negative (%)	< 0.1%
Memory size	29.3 MiB

Quantile statistics

Minimum	-6211.62
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	45000
Maximum	2287098.3
Range	2293309.9
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	33846.077
Coefficient of variation (CV)	4.5532504
Kurtosis	184.27441
Mean	7433.3882
Median Absolute Deviation (MAD)	0
Skewness	10.065626
Sum	2.854653 × 10¹⁰
Variance	1.145557 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3223443	83.9%
4500	30257	0.8%
9000	22968	0.6%
2250	20212	0.5%
45000	18947	0.5%
22500	18670	0.5%
13500	16964	0.4%
6750	12658	0.3%
18000	10729	0.3%
90000	10169	0.3%
Other values (186995)	455295	11.9%

Value	Count	Frequency (%)
-6211.62	1	< 0.1%
-1687.5	1	< 0.1%
-519.57	1	< 0.1%
0	3223443	83.9%
0.045	15	< 0.1%
0.09	12	< 0.1%
0.135	11	< 0.1%
0.18	15	< 0.1%
0.225	10	< 0.1%
0.27	15	< 0.1%

Value	Count	Frequency (%)
2287098.315	1	< 0.1%
2239274.16	1	< 0.1%
2115000	1	< 0.1%
2060030.16	1	< 0.1%
1992949.2	1	< 0.1%
1933462.125	1	< 0.1%
1840173.57	1	< 0.1%
1783581.885	1	< 0.1%
1750619.43	1	< 0.1%
1593098.01	1	< 0.1%

AMT_DRAWINGS_OTHER_CURRENT
Real number (ℝ)

High correlation Missing Skewed Zeros

Distinct	1832
Distinct (%)	0.1%
Missing	749816
Missing (%)	19.5%
Infinite	0
Infinite (%)	0.0%
Mean	288.16958

Minimum	0
Maximum	1529847
Zeros	3078163
Zeros (%)	80.2%
Negative	0
Negative (%)	0.0%
Memory size	29.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	1529847
Range	1529847
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	8201.9893
Coefficient of variation (CV)	28.46237
Kurtosis	3628.0099
Mean	288.16958
Median Absolute Deviation (MAD)	0
Skewness	50.57035
Sum	8.9058694 × 10⁸
Variance	67272629
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3078163	80.2%
3343.5	782	< 0.1%
6682.5	460	< 0.1%
4455	441	< 0.1%
8910	319	< 0.1%
46800	242	< 0.1%
4680	235	< 0.1%
9360	216	< 0.1%
23400	209	< 0.1%
5571	195	< 0.1%
Other values (1822)	9234	0.2%
(Missing)	749816	19.5%

Value	Count	Frequency (%)
0	3078163	80.2%
234	1	< 0.1%
280.8	1	< 0.1%
459	2	< 0.1%
461.25	1	< 0.1%
468	4	< 0.1%
573.3	1	< 0.1%
695.25	1	< 0.1%
702	3	< 0.1%
826.2	1	< 0.1%

Value	Count	Frequency (%)
1529847	1	< 0.1%
1302750	1	< 0.1%
900000	2	< 0.1%
899910	2	< 0.1%
899437.5	1	< 0.1%
898560	2	< 0.1%
898546.5	1	< 0.1%
872100	1	< 0.1%
853740	1	< 0.1%
819000	1	< 0.1%

AMT_DRAWINGS_POS_CURRENT
Real number (ℝ)

High correlation Missing Zeros

Distinct	168748
Distinct (%)	5.5%
Missing	749816
Missing (%)	19.5%
Infinite	0
Infinite (%)	0.0%
Mean	2968.8048

Minimum	0
Maximum	2239274.2
Zeros	2825595
Zeros (%)	73.6%
Negative	0
Negative (%)	0.0%
Memory size	29.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	10116
Maximum	2239274.2
Range	2239274.2
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	20796.887
Coefficient of variation (CV)	7.0051378
Kurtosis	713.98839
Mean	2968.8048
Median Absolute Deviation (MAD)	0
Skewness	19.421081
Sum	9.1750795 × 10⁹
Variance	4.3251051 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2825595	73.6%
450	1287	< 0.1%
900	976	< 0.1%
2250	910	< 0.1%
4500	801	< 0.1%
1350	784	< 0.1%
225	609	< 0.1%
45000	462	< 0.1%
1800	407	< 0.1%
2700	379	< 0.1%
Other values (168738)	258286	6.7%
(Missing)	749816	19.5%

Value	Count	Frequency (%)
0	2825595	73.6%
0.045	1	< 0.1%
0.225	1	< 0.1%
0.45	1	< 0.1%
0.495	1	< 0.1%
0.54	1	< 0.1%
1.125	1	< 0.1%
1.215	1	< 0.1%
1.305	1	< 0.1%
2.025	2	< 0.1%

Value	Count	Frequency (%)
2239274.16	1	< 0.1%
2060030.16	1	< 0.1%
1933462.125	1	< 0.1%
1896559.2	1	< 0.1%
1840173.57	1	< 0.1%
1750619.43	1	< 0.1%
1593098.01	1	< 0.1%
1579904.37	1	< 0.1%
1495476	1	< 0.1%
1495308.42	1	< 0.1%

AMT_INST_MIN_REGULARITY
Real number (ℝ)

High correlation Missing Zeros

Distinct	312266
Distinct (%)	8.8%
Missing	305236
Missing (%)	7.9%
Infinite	0
Infinite (%)	0.0%
Mean	3540.2041

Minimum	0
Maximum	202882.01
Zeros	1928864
Zeros (%)	50.2%
Negative	0
Negative (%)	0.0%
Memory size	29.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	6633.9112
95-th percentile	13500
Maximum	202882.01
Range	202882.01
Interquartile range (IQR)	6633.9112

Descriptive statistics

Standard deviation	5600.1541
Coefficient of variation (CV)	1.5818732
Kurtosis	10.182549
Mean	3540.2041
Median Absolute Deviation (MAD)	0
Skewness	2.4944311
Sum	1.2514891 × 10¹⁰
Variance	31361726
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1928864	50.2%
9000	225429	5.9%
6750	147469	3.8%
3375	127613	3.3%
4500	124979	3.3%
2250	108350	2.8%
5625	82303	2.1%
7875	53931	1.4%
8100	34436	0.9%
10800	28194	0.7%
Other values (312256)	673508	17.5%
(Missing)	305236	7.9%

Value	Count	Frequency (%)
0	1928864	50.2%
0.045	149	< 0.1%
0.09	168	< 0.1%
0.135	56	< 0.1%
0.18	151	< 0.1%
0.225	150	< 0.1%
0.27	59	< 0.1%
0.315	26	< 0.1%
0.36	30	< 0.1%
0.405	61	< 0.1%

Value	Count	Frequency (%)
202882.005	1	< 0.1%
194198.31	1	< 0.1%
188976.6	1	< 0.1%
136760.625	1	< 0.1%
126728.145	1	< 0.1%
95604.21	2	< 0.1%
94903.965	1	< 0.1%
89710.65	1	< 0.1%
84588.3	1	< 0.1%
80755.245	2	< 0.1%

AMT_PAYMENT_CURRENT
Real number (ℝ)

High correlation Missing Zeros

Distinct	163209
Distinct (%)	5.3%
Missing	767988
Missing (%)	20.0%
Infinite	0
Infinite (%)	0.0%
Mean	10280.538

Minimum	0
Maximum	4289207.4
Zeros	390507
Zeros (%)	10.2%
Negative	0
Negative (%)	0.0%
Memory size	29.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	152.37
median	2702.7
Q3	9000
95-th percentile	31500
Maximum	4289207.4
Range	4289207.4
Interquartile range (IQR)	8847.63

Descriptive statistics

Standard deviation	36078.085
Coefficient of variation (CV)	3.5093578
Kurtosis	315.7569
Mean	10280.538
Median Absolute Deviation (MAD)	2702.7
Skewness	12.990581
Sum	3.1585143 × 10¹⁰
Variance	1.3016282 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	390507	10.2%
9000	257297	6.7%
4500	143572	3.7%
6750	128296	3.3%
13500	100454	2.6%
22500	56016	1.5%
11250	45497	1.2%
3375	44600	1.2%
18000	37897	1.0%
5625	35591	0.9%
Other values (163199)	1832597	47.7%
(Missing)	767988	20.0%

Value	Count	Frequency (%)
0	390507	10.2%
0.045	1585	< 0.1%
0.09	1094	< 0.1%
0.135	1364	< 0.1%
0.18	1260	< 0.1%
0.225	641	< 0.1%
0.27	1113	< 0.1%
0.315	897	< 0.1%
0.36	937	< 0.1%
0.405	657	< 0.1%

Value	Count	Frequency (%)
4289207.445	1	< 0.1%
2497500	1	< 0.1%
2436495.255	1	< 0.1%
2287098.315	1	< 0.1%
2115000	1	< 0.1%
1981395	1	< 0.1%
1941419.205	1	< 0.1%
1931526.27	1	< 0.1%
1849337.01	1	< 0.1%
1833509.385	1	< 0.1%

AMT_PAYMENT_TOTAL_CURRENT
Real number (ℝ)

High correlation Zeros

Distinct	182957
Distinct (%)	4.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7588.8567

Minimum	0
Maximum	4278315.7
Zeros	2172223
Zeros (%)	56.6%
Negative	0
Negative (%)	0.0%
Memory size	29.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	6750
95-th percentile	23400
Maximum	4278315.7
Range	4278315.7
Interquartile range (IQR)	6750

Descriptive statistics

Standard deviation	32005.988
Coefficient of variation (CV)	4.217498
Kurtosis	393.25584
Mean	7588.8567
Median Absolute Deviation (MAD)	0
Skewness	14.479719
Sum	2.9143578 × 10¹⁰
Variance	1.0243833 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2172223	56.6%
9000	250826	6.5%
4500	139736	3.6%
6750	126483	3.3%
13500	94005	2.4%
22500	49059	1.3%
3375	44678	1.2%
11250	42999	1.1%
5625	35558	0.9%
18000	34154	0.9%
Other values (182947)	850591	22.1%

Value	Count	Frequency (%)
0	2172223	56.6%
0.045	444	< 0.1%
0.09	589	< 0.1%
0.135	386	< 0.1%
0.18	559	< 0.1%
0.225	324	< 0.1%
0.27	365	< 0.1%
0.315	469	< 0.1%
0.36	380	< 0.1%
0.405	329	< 0.1%

Value	Count	Frequency (%)
4278315.69	1	< 0.1%
2495250	1	< 0.1%
2436495.255	1	< 0.1%
2286980.73	1	< 0.1%
2115000	1	< 0.1%
1981395	1	< 0.1%
1941419.205	1	< 0.1%
1931301.27	1	< 0.1%
1849112.01	1	< 0.1%
1833509.385	1	< 0.1%

AMT_RECEIVABLE_PRINCIPAL
Real number (ℝ)

High correlation Zeros

Distinct	1195839
Distinct (%)	31.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	55965.877

Minimum	-423305.82
Maximum	1472316.8
Zeros	2296167
Zeros (%)	59.8%
Negative	2428
Negative (%)	0.1%
Memory size	29.3 MiB

Quantile statistics

Minimum	-423305.82
5-th percentile	0
Q1	0
median	0
Q3	85359.24
95-th percentile	247803.41
Maximum	1472316.8
Range	1895622.6
Interquartile range (IQR)	85359.24

Descriptive statistics

Standard deviation	102533.62
Coefficient of variation (CV)	1.8320738
Kurtosis	11.958459
Mean	55965.877
Median Absolute Deviation (MAD)	0
Skewness	2.9423162
Sum	2.1492643 × 10¹¹
Variance	1.0513143 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2296167	59.8%
45000	5072	0.1%
90000	4767	0.1%
135000	4513	0.1%
67500	3537	0.1%
180000	3256	0.1%
112500	2034	0.1%
22500	1283	< 0.1%
225000	1229	< 0.1%
157500	1212	< 0.1%
Other values (1195829)	1517242	39.5%

Value	Count	Frequency (%)
-423305.82	1	< 0.1%
-270288	1	< 0.1%
-267615	1	< 0.1%
-241042.005	1	< 0.1%
-225000	1	< 0.1%
-223224.21	1	< 0.1%
-202735.89	1	< 0.1%
-189000	1	< 0.1%
-135867.105	1	< 0.1%
-133982.235	1	< 0.1%

Value	Count	Frequency (%)
1472316.795	1	< 0.1%
1354829.265	1	< 0.1%
1329264.63	1	< 0.1%
1325147.4	1	< 0.1%
1305440.145	1	< 0.1%
1229704.065	1	< 0.1%
1198599.435	1	< 0.1%
1185785.685	1	< 0.1%
1183951.8	1	< 0.1%
1150643.16	1	< 0.1%

AMT_RECIVABLE
Real number (ℝ)

High correlation Zeros

Distinct	1338878
Distinct (%)	34.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	58088.811

Minimum	-420250.18
Maximum	1493338.2
Zeros	2113816
Zeros (%)	55.0%
Negative	109338
Negative (%)	2.8%
Memory size	29.3 MiB

Quantile statistics

Minimum	-420250.18
5-th percentile	0
Q1	0
median	0
Q3	88899.491
95-th percentile	256445.41
Maximum	1493338.2
Range	1913588.4
Interquartile range (IQR)	88899.491

Descriptive statistics

Standard deviation	105965.37
Coefficient of variation (CV)	1.8241959
Kurtosis	11.71959
Mean	58088.811
Median Absolute Deviation (MAD)	0
Skewness	2.9131725
Sum	2.2307916 × 10¹¹
Variance	1.122866 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2113816	55.0%
67.5	3144	0.1%
270	2301	0.1%
130.5	825	< 0.1%
135	756	< 0.1%
202.5	699	< 0.1%
45000	645	< 0.1%
450	310	< 0.1%
90000	264	< 0.1%
135000	255	< 0.1%
Other values (1338868)	1717297	44.7%

Value	Count	Frequency (%)
-420250.185	1	< 0.1%
-268834.545	1	< 0.1%
-261777.015	1	< 0.1%
-239950.485	1	< 0.1%
-224569.71	1	< 0.1%
-223224.21	1	< 0.1%
-202380.39	1	< 0.1%
-186505.2	1	< 0.1%
-133442.235	1	< 0.1%
-131946.39	1	< 0.1%

Value	Count	Frequency (%)
1493338.185	1	< 0.1%
1354829.265	1	< 0.1%
1341252	1	< 0.1%
1334196.765	1	< 0.1%
1329264.63	1	< 0.1%
1229704.065	1	< 0.1%
1214812.395	1	< 0.1%
1210510.755	1	< 0.1%
1205441.64	1	< 0.1%
1150643.16	1	< 0.1%

AMT_TOTAL_RECEIVABLE
Real number (ℝ)

High correlation Zeros

Distinct	1339008
Distinct (%)	34.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	58098.285

Minimum	-420250.18
Maximum	1493338.2
Zeros	2113643
Zeros (%)	55.0%
Negative	109330
Negative (%)	2.8%
Memory size	29.3 MiB

Quantile statistics

Minimum	-420250.18
5-th percentile	0
Q1	0
median	0
Q3	88914.51
95-th percentile	256468.5
Maximum	1493338.2
Range	1913588.4
Interquartile range (IQR)	88914.51

Descriptive statistics

Standard deviation	105971.8
Coefficient of variation (CV)	1.8240091
Kurtosis	11.715925
Mean	58098.285
Median Absolute Deviation (MAD)	0
Skewness	2.9126841
Sum	2.2311554 × 10¹¹
Variance	1.1230023 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2113643	55.0%
67.5	3144	0.1%
270	2301	0.1%
130.5	825	< 0.1%
135	756	< 0.1%
202.5	699	< 0.1%
45000	645	< 0.1%
450	310	< 0.1%
90000	264	< 0.1%
135000	255	< 0.1%
Other values (1338998)	1717470	44.7%

Value	Count	Frequency (%)
-420250.185	1	< 0.1%
-268834.545	1	< 0.1%
-261777.015	1	< 0.1%
-239950.485	1	< 0.1%
-224569.71	1	< 0.1%
-223224.21	1	< 0.1%
-202380.39	1	< 0.1%
-186505.2	1	< 0.1%
-133442.235	1	< 0.1%
-131946.39	1	< 0.1%

Value	Count	Frequency (%)
1493338.185	1	< 0.1%
1354829.265	1	< 0.1%
1341252	1	< 0.1%
1334196.765	1	< 0.1%
1329264.63	1	< 0.1%
1229704.065	1	< 0.1%
1214812.395	1	< 0.1%
1210510.755	1	< 0.1%
1205441.64	1	< 0.1%
1150643.16	1	< 0.1%

CNT_DRAWINGS_ATM_CURRENT
Real number (ℝ)

High correlation Missing Zeros

Distinct	44
Distinct (%)	< 0.1%
Missing	749816
Missing (%)	19.5%
Infinite	0
Infinite (%)	0.0%
Mean	0.30944903

Minimum	0
Maximum	51
Zeros	2665718
Zeros (%)	69.4%
Negative	0
Negative (%)	0.0%
Memory size	29.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	2
Maximum	51
Range	51
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.1004012
Coefficient of variation (CV)	3.5560013
Kurtosis	81.549383
Mean	0.30944903
Median Absolute Deviation (MAD)	0
Skewness	6.9066553
Sum	956351
Variance	1.2108828
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=44)

Value	Count	Frequency (%)
0	2665718	69.4%
1	213460	5.6%
2	95647	2.5%
3	46730	1.2%
4	26335	0.7%
5	14910	0.4%
6	9179	0.2%
7	5718	0.1%
8	3992	0.1%
9	2427	0.1%
Other values (34)	6380	0.2%
(Missing)	749816	19.5%

Value	Count	Frequency (%)
0	2665718	69.4%
1	213460	5.6%
2	95647	2.5%
3	46730	1.2%
4	26335	0.7%
5	14910	0.4%
6	9179	0.2%
7	5718	0.1%
8	3992	0.1%
9	2427	0.1%

Value	Count	Frequency (%)
51	1	< 0.1%
44	1	< 0.1%
43	1	< 0.1%
41	2	< 0.1%
39	2	< 0.1%
38	3	< 0.1%
37	2	< 0.1%
36	3	< 0.1%
35	4	< 0.1%
34	4	< 0.1%

CNT_DRAWINGS_CURRENT
Real number (ℝ)

High correlation Zeros

Distinct	129
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.70314391

Minimum	0
Maximum	165
Zeros	3229952
Zeros (%)	84.1%
Negative	0
Negative (%)	0.0%
Memory size	29.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	4
Maximum	165
Range	165
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	3.1903468
Coefficient of variation (CV)	4.5372601
Kurtosis	177.92831
Mean	0.70314391
Median Absolute Deviation (MAD)	0
Skewness	10.635288
Sum	2700292
Variance	10.178313
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3229952	84.1%
1	231319	6.0%
2	116762	3.0%
3	65318	1.7%
4	43290	1.1%
5	28987	0.8%
6	20768	0.5%
7	15872	0.4%
8	12345	0.3%
9	9534	0.2%
Other values (119)	66165	1.7%

Value	Count	Frequency (%)
0	3229952	84.1%
1	231319	6.0%
2	116762	3.0%
3	65318	1.7%
4	43290	1.1%
5	28987	0.8%
6	20768	0.5%
7	15872	0.4%
8	12345	0.3%
9	9534	0.2%

Value	Count	Frequency (%)
165	1	< 0.1%
162	2	< 0.1%
151	1	< 0.1%
143	1	< 0.1%
142	2	< 0.1%
136	1	< 0.1%
135	1	< 0.1%
130	2	< 0.1%
126	3	< 0.1%
124	4	< 0.1%

CNT_DRAWINGS_OTHER_CURRENT
Real number (ℝ)

High correlation Missing Skewed Zeros

Distinct	11
Distinct (%)	< 0.1%
Missing	749816
Missing (%)	19.5%
Infinite	0
Infinite (%)	0.0%
Mean	0.0048124961

Minimum	0
Maximum	12
Zeros	3077688
Zeros (%)	80.1%
Negative	0
Negative (%)	0.0%
Memory size	29.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	12
Range	12
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.082638612
Coefficient of variation (CV)	17.171674
Kurtosis	1253.2563
Mean	0.0048124961
Median Absolute Deviation (MAD)	0
Skewness	26.323819
Sum	14873
Variance	0.0068291402
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
0	3077688	80.1%
1	11354	0.3%
2	1076	< 0.1%
3	259	< 0.1%
4	65	< 0.1%
5	27	< 0.1%
6	11	< 0.1%
7	9	< 0.1%
8	3	< 0.1%
10	3	< 0.1%
(Missing)	749816	19.5%

Value	Count	Frequency (%)
0	3077688	80.1%
1	11354	0.3%
2	1076	< 0.1%
3	259	< 0.1%
4	65	< 0.1%
5	27	< 0.1%
6	11	< 0.1%
7	9	< 0.1%
8	3	< 0.1%
10	3	< 0.1%

Value	Count	Frequency (%)
12	1	< 0.1%
10	3	< 0.1%
8	3	< 0.1%
7	9	< 0.1%
6	11	< 0.1%
5	27	< 0.1%
4	65	< 0.1%
3	259	< 0.1%
2	1076	< 0.1%
1	11354	0.3%

CNT_DRAWINGS_POS_CURRENT
Real number (ℝ)

High correlation Missing Zeros

Distinct	133
Distinct (%)	< 0.1%
Missing	749816
Missing (%)	19.5%
Infinite	0
Infinite (%)	0.0%
Mean	0.55947913

Minimum	0
Maximum	165
Zeros	2825594
Zeros (%)	73.6%
Negative	0
Negative (%)	0.0%
Memory size	29.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	2
Maximum	165
Range	165
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	3.2406491
Coefficient of variation (CV)	5.7922609
Kurtosis	192.55102
Mean	0.55947913
Median Absolute Deviation (MAD)	0
Skewness	11.352616
Sum	1729068
Variance	10.501807
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2825594	73.6%
1	72216	1.9%
2	41061	1.1%
3	27337	0.7%
4	20273	0.5%
5	15149	0.4%
6	12133	0.3%
7	9773	0.3%
8	7993	0.2%
9	6627	0.2%
Other values (123)	52340	1.4%
(Missing)	749816	19.5%

Value	Count	Frequency (%)
0	2825594	73.6%
1	72216	1.9%
2	41061	1.1%
3	27337	0.7%
4	20273	0.5%
5	15149	0.4%
6	12133	0.3%
7	9773	0.3%
8	7993	0.2%
9	6627	0.2%

Value	Count	Frequency (%)
165	1	< 0.1%
162	2	< 0.1%
151	1	< 0.1%
143	1	< 0.1%
142	1	< 0.1%
140	1	< 0.1%
136	1	< 0.1%
135	1	< 0.1%
130	2	< 0.1%
126	2	< 0.1%

CNT_INSTALMENT_MATURE_CUM
Real number (ℝ)

Missing Zeros

Distinct	121
Distinct (%)	< 0.1%
Missing	305236
Missing (%)	7.9%
Infinite	0
Infinite (%)	0.0%
Mean	20.825084

Minimum	0
Maximum	120
Zeros	551467
Zeros (%)	14.4%
Negative	0
Negative (%)	0.0%
Memory size	29.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	4
median	15
Q3	32
95-th percentile	61
Maximum	120
Range	120
Interquartile range (IQR)	28

Descriptive statistics

Standard deviation	20.051494
Coefficient of variation (CV)	0.96285297
Kurtosis	0.64032881
Mean	20.825084
Median Absolute Deviation (MAD)	13
Skewness	1.0755883
Sum	73618254
Variance	402.0624
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	551467	14.4%
5	91691	2.4%
2	91035	2.4%
4	89941	2.3%
6	89829	2.3%
3	89492	2.3%
1	87306	2.3%
7	87177	2.3%
8	86882	2.3%
9	81423	2.1%
Other values (111)	2188833	57.0%
(Missing)	305236	7.9%

Value	Count	Frequency (%)
0	551467	14.4%
1	87306	2.3%
2	91035	2.4%
3	89492	2.3%
4	89941	2.3%
5	91691	2.4%
6	89829	2.3%
7	87177	2.3%
8	86882	2.3%
9	81423	2.1%

Value	Count	Frequency (%)
120	1	< 0.1%
119	2	< 0.1%
118	3	< 0.1%
117	4	< 0.1%
116	6	< 0.1%
115	10	< 0.1%
114	14	< 0.1%
113	19	< 0.1%
112	24	< 0.1%
111	32	< 0.1%

NAME_CONTRACT_STATUS
Categorical

Imbalance

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	231.1 MiB

Active	3698436
Completed	128918
Signed	11058
Demand	1365
Sent proposal	513
Other values (2)	22

Length

Max length	13
Median length	6
Mean length	6.1016511
Min length	6

Characters and Unicode

Total characters	23432244
Distinct characters	23
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Active
2nd row	Active
3rd row	Active
4th row	Active
5th row	Active

Common Values

Value	Count	Frequency (%)
Active	3698436	96.3%
Completed	128918	3.4%
Signed	11058	0.3%
Demand	1365	< 0.1%
Sent proposal	513	< 0.1%
Refused	17	< 0.1%
Approved	5	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
active	3698436	96.3%
completed	128918	3.4%
signed	11058	0.3%
demand	1365	< 0.1%
sent	513	< 0.1%
proposal	513	< 0.1%
refused	17	< 0.1%
approved	5	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
e	3969247	16.9%
t	3827867	16.3%
i	3709494	15.8%
A	3698441	15.8%
v	3698441	15.8%
c	3698436	15.8%
d	141363	0.6%
m	130283	0.6%
p	129954	0.6%
o	129949	0.6%
Other values (13)	298769	1.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	23432244	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	3969247	16.9%
t	3827867	16.3%
i	3709494	15.8%
A	3698441	15.8%
v	3698441	15.8%
c	3698436	15.8%
d	141363	0.6%
m	130283	0.6%
p	129954	0.6%
o	129949	0.6%
Other values (13)	298769	1.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	23432244	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	3969247	16.9%
t	3827867	16.3%
i	3709494	15.8%
A	3698441	15.8%
v	3698441	15.8%
c	3698436	15.8%
d	141363	0.6%
m	130283	0.6%
p	129954	0.6%
o	129949	0.6%
Other values (13)	298769	1.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	23432244	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	3969247	16.9%
t	3827867	16.3%
i	3709494	15.8%
A	3698441	15.8%
v	3698441	15.8%
c	3698436	15.8%
d	141363	0.6%
m	130283	0.6%
p	129954	0.6%
o	129949	0.6%
Other values (13)	298769	1.3%

SK_DPD
Real number (ℝ)

High correlation Zeros

Distinct	917
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.2836673

Minimum	0
Maximum	3260
Zeros	3686957
Zeros (%)	96.0%
Negative	0
Negative (%)	0.0%
Memory size	29.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	3260
Range	3260
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	97.5157
Coefficient of variation (CV)	10.504006
Kurtosis	190.37264
Mean	9.2836673
Median Absolute Deviation (MAD)	0
Skewness	12.94699
Sum	35652179
Variance	9509.3118
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3686957	96.0%
1	90369	2.4%
8	2772	0.1%
32	2340	0.1%
7	1797	< 0.1%
62	1406	< 0.1%
31	1290	< 0.1%
366	959	< 0.1%
93	899	< 0.1%
18	837	< 0.1%
Other values (907)	50686	1.3%

Value	Count	Frequency (%)
0	3686957	96.0%
1	90369	2.4%
5	532	< 0.1%
6	99	< 0.1%
7	1797	< 0.1%
8	2772	0.1%
9	37	< 0.1%
10	9	< 0.1%
11	152	< 0.1%
12	222	< 0.1%

Value	Count	Frequency (%)
3260	1	< 0.1%
3229	1	< 0.1%
3198	1	< 0.1%
3168	1	< 0.1%
3137	1	< 0.1%
3107	1	< 0.1%
3076	1	< 0.1%
3045	1	< 0.1%
3015	1	< 0.1%
2984	1	< 0.1%

SK_DPD_DEF
Real number (ℝ)

High correlation Skewed Zeros

Distinct	378
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.33162201

Minimum	0
Maximum	3260
Zeros	3750972
Zeros (%)	97.7%
Negative	0
Negative (%)	0.0%
Memory size	29.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	3260
Range	3260
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	21.479231
Coefficient of variation (CV)	64.770222
Kurtosis	9007.739
Mean	0.33162201
Median Absolute Deviation (MAD)	0
Skewness	89.830434
Sum	1273532
Variance	461.35738
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3750972	97.7%
1	83080	2.2%
8	1729	< 0.1%
7	1176	< 0.1%
32	492	< 0.1%
5	406	< 0.1%
31	291	< 0.1%
18	253	< 0.1%
12	125	< 0.1%
62	114	< 0.1%
Other values (368)	1674	< 0.1%

Value	Count	Frequency (%)
0	3750972	97.7%
1	83080	2.2%
5	406	< 0.1%
6	83	< 0.1%
7	1176	< 0.1%
8	1729	< 0.1%
9	24	< 0.1%
10	7	< 0.1%
11	82	< 0.1%
12	125	< 0.1%

Value	Count	Frequency (%)
3260	1	< 0.1%
3229	1	< 0.1%
3198	1	< 0.1%
3168	1	< 0.1%
3137	1	< 0.1%
3107	1	< 0.1%
3076	1	< 0.1%
3045	1	< 0.1%
3015	1	< 0.1%
2984	1	< 0.1%

Interactions

Correlations

	AMT_BALANCE	AMT_CREDIT_LIMIT_ACTUAL	AMT_DRAWINGS_ATM_CURRENT	AMT_DRAWINGS_CURRENT	AMT_DRAWINGS_OTHER_CURRENT	AMT_DRAWINGS_POS_CURRENT	AMT_INST_MIN_REGULARITY	AMT_PAYMENT_CURRENT	AMT_PAYMENT_TOTAL_CURRENT	AMT_RECEIVABLE_PRINCIPAL	AMT_RECIVABLE	AMT_TOTAL_RECEIVABLE	CNT_DRAWINGS_ATM_CURRENT	CNT_DRAWINGS_CURRENT	CNT_DRAWINGS_OTHER_CURRENT	CNT_DRAWINGS_POS_CURRENT	CNT_INSTALMENT_MATURE_CUM	MONTHS_BALANCE	NAME_CONTRACT_STATUS	SK_DPD	SK_DPD_DEF	SK_ID_CURR	SK_ID_PREV
AMT_BALANCE	1.000	0.466	0.419	0.504	0.058	0.269	0.919	0.683	0.799	0.977	0.971	0.971	0.420	0.508	0.055	0.270	0.129	-0.166	0.030	0.155	0.163	0.003	0.000
AMT_CREDIT_LIMIT_ACTUAL	0.466	1.000	0.274	0.310	0.030	0.277	0.486	0.490	0.431	0.460	0.458	0.458	0.270	0.309	0.026	0.275	-0.076	0.067	0.020	0.003	0.023	0.007	0.005
AMT_DRAWINGS_ATM_CURRENT	0.419	0.274	1.000	0.808	0.014	0.180	0.299	0.276	0.279	0.413	0.407	0.407	0.997	0.787	0.012	0.180	-0.125	0.001	0.006	-0.025	0.009	0.003	0.004
AMT_DRAWINGS_CURRENT	0.504	0.310	0.808	1.000	0.133	0.621	0.372	0.361	0.404	0.502	0.491	0.490	0.804	0.990	0.130	0.619	-0.075	0.076	0.005	-0.025	0.005	0.003	0.001
AMT_DRAWINGS_OTHER_CURRENT	0.058	0.030	0.014	0.133	1.000	0.009	0.025	0.020	0.020	0.058	0.057	0.057	0.013	0.117	0.981	0.008	-0.025	-0.030	0.002	-0.004	0.001	-0.001	-0.002
AMT_DRAWINGS_POS_CURRENT	0.269	0.277	0.180	0.621	0.009	1.000	0.187	0.272	0.262	0.269	0.263	0.263	0.179	0.661	0.008	0.999	-0.226	0.257	0.003	-0.054	-0.037	0.001	0.003
AMT_INST_MIN_REGULARITY	0.919	0.486	0.299	0.372	0.025	0.187	1.000	0.757	0.852	0.903	0.887	0.887	0.302	0.380	0.022	0.189	0.173	-0.243	0.058	0.072	0.156	0.003	0.003
AMT_PAYMENT_CURRENT	0.683	0.490	0.276	0.361	0.020	0.272	0.757	1.000	0.882	0.670	0.642	0.642	0.276	0.368	0.019	0.272	-0.125	-0.078	0.003	-0.216	-0.116	0.003	0.006
AMT_PAYMENT_TOTAL_CURRENT	0.799	0.431	0.279	0.404	0.020	0.262	0.852	0.882	1.000	0.777	0.764	0.764	0.280	0.410	0.017	0.263	0.096	-0.122	0.003	-0.070	-0.017	0.004	-0.001
AMT_RECEIVABLE_PRINCIPAL	0.977	0.460	0.413	0.502	0.058	0.269	0.903	0.670	0.777	1.000	0.971	0.971	0.414	0.506	0.054	0.269	0.105	-0.154	0.031	0.077	0.163	0.004	0.001
AMT_RECIVABLE	0.971	0.458	0.407	0.491	0.057	0.263	0.887	0.642	0.764	0.971	1.000	1.000	0.408	0.494	0.053	0.263	0.101	-0.132	0.031	0.154	0.163	0.003	0.000
AMT_TOTAL_RECEIVABLE	0.971	0.458	0.407	0.490	0.057	0.263	0.887	0.642	0.764	0.971	1.000	1.000	0.408	0.494	0.053	0.263	0.101	-0.132	0.031	0.154	0.163	0.003	0.000
CNT_DRAWINGS_ATM_CURRENT	0.420	0.270	0.997	0.804	0.013	0.179	0.302	0.276	0.280	0.414	0.408	0.408	1.000	0.789	0.012	0.180	-0.122	-0.004	0.010	-0.023	0.011	0.003	0.003
CNT_DRAWINGS_CURRENT	0.508	0.309	0.787	0.990	0.117	0.661	0.380	0.368	0.410	0.506	0.494	0.494	0.789	1.000	0.119	0.662	-0.076	0.079	0.007	-0.024	0.007	0.003	0.001
CNT_DRAWINGS_OTHER_CURRENT	0.055	0.026	0.012	0.130	0.981	0.008	0.022	0.019	0.017	0.054	0.053	0.053	0.012	0.119	1.000	0.008	-0.024	-0.029	0.002	-0.004	0.000	-0.000	-0.002
CNT_DRAWINGS_POS_CURRENT	0.270	0.275	0.180	0.619	0.008	0.999	0.189	0.272	0.263	0.269	0.263	0.263	0.180	0.662	0.008	1.000	-0.226	0.259	0.009	-0.054	-0.037	0.001	0.003
CNT_INSTALMENT_MATURE_CUM	0.129	-0.076	-0.125	-0.075	-0.025	-0.226	0.173	-0.125	0.096	0.105	0.101	0.101	-0.122	-0.076	-0.024	-0.226	1.000	-0.204	0.055	0.125	0.081	0.000	-0.007
MONTHS_BALANCE	-0.166	0.067	0.001	0.076	-0.030	0.257	-0.243	-0.078	-0.122	-0.154	-0.132	-0.132	-0.004	0.079	-0.029	0.259	-0.204	1.000	0.082	-0.105	-0.128	0.001	0.003
NAME_CONTRACT_STATUS	0.030	0.020	0.006	0.005	0.002	0.003	0.058	0.003	0.003	0.031	0.031	0.031	0.010	0.007	0.002	0.009	0.055	0.082	1.000	0.094	0.285	0.006	0.008
SK_DPD	0.155	0.003	-0.025	-0.025	-0.004	-0.054	0.072	-0.216	-0.070	0.077	0.154	0.154	-0.023	-0.024	-0.004	-0.054	0.125	-0.105	0.094	1.000	0.745	-0.002	-0.004
SK_DPD_DEF	0.163	0.023	0.009	0.005	0.001	-0.037	0.156	-0.116	-0.017	0.163	0.163	0.163	0.011	0.007	0.000	-0.037	0.081	-0.128	0.285	0.745	1.000	-0.001	-0.004
SK_ID_CURR	0.003	0.007	0.003	0.003	-0.001	0.001	0.003	0.003	0.004	0.004	0.003	0.003	0.003	0.003	-0.000	0.001	0.000	0.001	0.006	-0.002	-0.001	1.000	0.005
SK_ID_PREV	0.000	0.005	0.004	0.001	-0.002	0.003	0.003	0.006	-0.001	0.001	0.000	0.000	0.003	0.001	-0.002	0.003	-0.007	0.003	0.008	-0.004	-0.004	0.005	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

	SK_ID_PREV	SK_ID_CURR	MONTHS_BALANCE	AMT_BALANCE	AMT_CREDIT_LIMIT_ACTUAL	AMT_DRAWINGS_ATM_CURRENT	AMT_DRAWINGS_CURRENT	AMT_DRAWINGS_POS_CURRENT	AMT_INST_MIN_REGULARITY	AMT_PAYMENT_CURRENT	AMT_PAYMENT_TOTAL_CURRENT	AMT_RECEIVABLE_PRINCIPAL	AMT_RECIVABLE	AMT_TOTAL_RECEIVABLE	CNT_DRAWINGS_ATM_CURRENT	CNT_DRAWINGS_CURRENT	CNT_DRAWINGS_POS_CURRENT	CNT_INSTALMENT_MATURE_CUM	NAME_CONTRACT_STATUS	SK_DPD
0	2562384	378907	-6	56.970	135000	0.0	877.500	877.500	1700.325	1800.000	1800.000	0.000	0.000	0.000	0.0	1	1.0	35.0	Active	0
1	2582071	363914	-1	63975.555	45000	2250.0	2250.000	0.000	2250.000	2250.000	2250.000	60175.080	64875.555	64875.555	1.0	1	0.0	69.0	Active	0
2	1740877	371185	-7	31815.225	450000	0.0	0.000	0.000	2250.000	2250.000	2250.000	26926.425	31460.085	31460.085	0.0	0	0.0	30.0	Active	0
3	1389973	337855	-4	236572.110	225000	2250.0	2250.000	0.000	11795.760	11925.000	11925.000	224949.285	233048.970	233048.970	1.0	1	0.0	10.0	Active	0
4	1891521	126868	-1	453919.455	450000	0.0	11547.000	11547.000	22924.890	27000.000	27000.000	443044.395	453919.455	453919.455	0.0	1	1.0	101.0	Active	0
5	2646502	380010	-7	82903.815	270000	0.0	0.000	0.000	4449.105	3825.000	3825.000	80519.040	82773.315	82773.315	0.0	0	0.0	2.0	Active	7
6	1079071	171320	-6	353451.645	585000	67500.0	67500.000	0.000	14684.175	15750.000	15750.000	345433.860	351881.145	351881.145	1.0	1	0.0	6.0	Active	0
7	2095912	118650	-7	47962.125	45000	45000.0	45000.000	0.000	0.000	264.690	0.000	44735.310	47962.125	47962.125	1.0	1	0.0	51.0	Active	0
8	2181852	367360	-4	291543.075	292500	90000.0	289339.425	199339.425	130.500	4093.515	4093.515	285376.410	286831.575	286831.575	3.0	8	5.0	3.0	Active	0
9	1235299	203885	-5	201261.195	225000	76500.0	111026.700	34526.700	6338.340	45000.000	45000.000	192793.275	197224.695	197224.695	3.0	9	6.0	38.0	Active	0

	SK_ID_PREV	SK_ID_CURR	MONTHS_BALANCE	AMT_BALANCE	AMT_CREDIT_LIMIT_ACTUAL	AMT_DRAWINGS_ATM_CURRENT	AMT_DRAWINGS_CURRENT	AMT_DRAWINGS_OTHER_CURRENT	AMT_DRAWINGS_POS_CURRENT	AMT_INST_MIN_REGULARITY	AMT_PAYMENT_CURRENT	AMT_PAYMENT_TOTAL_CURRENT	AMT_RECEIVABLE_PRINCIPAL	AMT_RECIVABLE	AMT_TOTAL_RECEIVABLE	CNT_DRAWINGS_ATM_CURRENT	CNT_DRAWINGS_CURRENT	CNT_DRAWINGS_OTHER_CURRENT	CNT_DRAWINGS_POS_CURRENT	CNT_INSTALMENT_MATURE_CUM	NAME_CONTRACT_STATUS
3840302	2032117	355450	-11	0.000	45000	0.0	0.0	0.0	0.0	0.0	3157.920	0.000	0.00	0.000	0.000	0.0	0	0.0	0.0	36.0	Active
3840303	1307188	385981	-9	0.000	0	NaN	0.0	NaN	NaN	0.0	NaN	0.000	0.00	0.000	0.000	NaN	0	NaN	NaN	0.0	Active
3840304	1301378	303373	-15	0.000	0	0.0	0.0	0.0	0.0	0.0	360.225	0.000	0.00	0.000	0.000	0.0	0	0.0	0.0	60.0	Active
3840305	2621524	172581	-11	0.000	0	0.0	0.0	0.0	0.0	0.0	4.860	0.000	0.00	0.000	0.000	0.0	0	0.0	0.0	21.0	Active
3840306	1410474	255737	-13	0.000	180000	NaN	0.0	NaN	NaN	0.0	NaN	0.000	0.00	0.000	0.000	NaN	0	NaN	NaN	0.0	Active
3840307	1036507	328243	-9	0.000	45000	NaN	0.0	NaN	NaN	0.0	NaN	0.000	0.00	0.000	0.000	NaN	0	NaN	NaN	0.0	Active
3840308	1714892	347207	-9	0.000	45000	0.0	0.0	0.0	0.0	0.0	1879.110	0.000	0.00	0.000	0.000	0.0	0	0.0	0.0	23.0	Active
3840309	1302323	215757	-9	275784.975	585000	270000.0	270000.0	0.0	0.0	2250.0	375750.000	356994.675	269356.14	273093.975	273093.975	2.0	2	0.0	0.0	18.0	Active
3840310	1624872	430337	-10	0.000	450000	NaN	0.0	NaN	NaN	0.0	NaN	0.000	0.00	0.000	0.000	NaN	0	NaN	NaN	0.0	Active
3840311	2411345	236760	-10	0.000	157500	0.0	0.0	0.0	0.0	0.0	0.000	0.000	0.00	0.000	0.000	0.0	0	0.0	0.0	21.0	Completed

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample